﻿
namespace mal.web.Balades.Business.UnitTest.Bootstrap
{
    class PictureBootstrap : BootstrapBase
    {
        #region Fields

        #endregion

        #region Construction / Destruction

        #endregion

        #region enum, struct, class

        #endregion

        #region Properties

        #endregion

        #region Methods
        public override void Fill()
        {
            this.ExecuteQuery("DBCC CHECKIDENT (balades_picture, reseed, 0)");

            for (int i = 0; i < 10; i++)
            {
                for (int j = 0; j < i+1; j++)
                {
                    this.ExecuteQuery(@"insert balades_Picture(PictureTypeID,VisitID
                        ,[Rank],[Text],Title,Url)
	                    values(1,{0},{1}, 'picture {0}-{1}'
                        , 'picture {0}-{1}','picture-{0}-{1}' )", i + 1, j + 1);
                }               
            }
        }

        public override void Clean()
        {
            this.ExecuteQuery("Delete balades_picture");
        }
        #endregion

        #region Events

        #endregion



    }
}
